package com.yunche.iov.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class VehicleExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public VehicleExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andPlateNoIsNull() {
            addCriterion("plate_no is null");
            return (Criteria) this;
        }

        public Criteria andPlateNoIsNotNull() {
            addCriterion("plate_no is not null");
            return (Criteria) this;
        }

        public Criteria andPlateNoEqualTo(String value) {
            addCriterion("plate_no =", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoNotEqualTo(String value) {
            addCriterion("plate_no <>", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoGreaterThan(String value) {
            addCriterion("plate_no >", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoGreaterThanOrEqualTo(String value) {
            addCriterion("plate_no >=", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoLessThan(String value) {
            addCriterion("plate_no <", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoLessThanOrEqualTo(String value) {
            addCriterion("plate_no <=", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoLike(String value) {
            addCriterion("plate_no like", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoNotLike(String value) {
            addCriterion("plate_no not like", value, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoIn(List<String> values) {
            addCriterion("plate_no in", values, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoNotIn(List<String> values) {
            addCriterion("plate_no not in", values, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoBetween(String value1, String value2) {
            addCriterion("plate_no between", value1, value2, "plateNo");
            return (Criteria) this;
        }

        public Criteria andPlateNoNotBetween(String value1, String value2) {
            addCriterion("plate_no not between", value1, value2, "plateNo");
            return (Criteria) this;
        }

        public Criteria andVinIsNull() {
            addCriterion("vin is null");
            return (Criteria) this;
        }

        public Criteria andVinIsNotNull() {
            addCriterion("vin is not null");
            return (Criteria) this;
        }

        public Criteria andVinEqualTo(String value) {
            addCriterion("vin =", value, "vin");
            return (Criteria) this;
        }

        public Criteria andVinNotEqualTo(String value) {
            addCriterion("vin <>", value, "vin");
            return (Criteria) this;
        }

        public Criteria andVinGreaterThan(String value) {
            addCriterion("vin >", value, "vin");
            return (Criteria) this;
        }

        public Criteria andVinGreaterThanOrEqualTo(String value) {
            addCriterion("vin >=", value, "vin");
            return (Criteria) this;
        }

        public Criteria andVinLessThan(String value) {
            addCriterion("vin <", value, "vin");
            return (Criteria) this;
        }

        public Criteria andVinLessThanOrEqualTo(String value) {
            addCriterion("vin <=", value, "vin");
            return (Criteria) this;
        }

        public Criteria andVinLike(String value) {
            addCriterion("vin like", value, "vin");
            return (Criteria) this;
        }

        public Criteria andVinNotLike(String value) {
            addCriterion("vin not like", value, "vin");
            return (Criteria) this;
        }

        public Criteria andVinIn(List<String> values) {
            addCriterion("vin in", values, "vin");
            return (Criteria) this;
        }

        public Criteria andVinNotIn(List<String> values) {
            addCriterion("vin not in", values, "vin");
            return (Criteria) this;
        }

        public Criteria andVinBetween(String value1, String value2) {
            addCriterion("vin between", value1, value2, "vin");
            return (Criteria) this;
        }

        public Criteria andVinNotBetween(String value1, String value2) {
            addCriterion("vin not between", value1, value2, "vin");
            return (Criteria) this;
        }

        public Criteria andOwnerIdIsNull() {
            addCriterion("owner_id is null");
            return (Criteria) this;
        }

        public Criteria andOwnerIdIsNotNull() {
            addCriterion("owner_id is not null");
            return (Criteria) this;
        }

        public Criteria andOwnerIdEqualTo(Integer value) {
            addCriterion("owner_id =", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdNotEqualTo(Integer value) {
            addCriterion("owner_id <>", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdGreaterThan(Integer value) {
            addCriterion("owner_id >", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("owner_id >=", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdLessThan(Integer value) {
            addCriterion("owner_id <", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdLessThanOrEqualTo(Integer value) {
            addCriterion("owner_id <=", value, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdIn(List<Integer> values) {
            addCriterion("owner_id in", values, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdNotIn(List<Integer> values) {
            addCriterion("owner_id not in", values, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdBetween(Integer value1, Integer value2) {
            addCriterion("owner_id between", value1, value2, "ownerId");
            return (Criteria) this;
        }

        public Criteria andOwnerIdNotBetween(Integer value1, Integer value2) {
            addCriterion("owner_id not between", value1, value2, "ownerId");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNull() {
            addCriterion("create_by is null");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNotNull() {
            addCriterion("create_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByEqualTo(Integer value) {
            addCriterion("create_by =", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotEqualTo(Integer value) {
            addCriterion("create_by <>", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThan(Integer value) {
            addCriterion("create_by >", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThanOrEqualTo(Integer value) {
            addCriterion("create_by >=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThan(Integer value) {
            addCriterion("create_by <", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThanOrEqualTo(Integer value) {
            addCriterion("create_by <=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByIn(List<Integer> values) {
            addCriterion("create_by in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotIn(List<Integer> values) {
            addCriterion("create_by not in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByBetween(Integer value1, Integer value2) {
            addCriterion("create_by between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotBetween(Integer value1, Integer value2) {
            addCriterion("create_by not between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNull() {
            addCriterion("update_by is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNotNull() {
            addCriterion("update_by is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByEqualTo(Integer value) {
            addCriterion("update_by =", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotEqualTo(Integer value) {
            addCriterion("update_by <>", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThan(Integer value) {
            addCriterion("update_by >", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThanOrEqualTo(Integer value) {
            addCriterion("update_by >=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThan(Integer value) {
            addCriterion("update_by <", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThanOrEqualTo(Integer value) {
            addCriterion("update_by <=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByIn(List<Integer> values) {
            addCriterion("update_by in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotIn(List<Integer> values) {
            addCriterion("update_by not in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByBetween(Integer value1, Integer value2) {
            addCriterion("update_by between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotBetween(Integer value1, Integer value2) {
            addCriterion("update_by not between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andModelIdIsNull() {
            addCriterion("model_id is null");
            return (Criteria) this;
        }

        public Criteria andModelIdIsNotNull() {
            addCriterion("model_id is not null");
            return (Criteria) this;
        }

        public Criteria andModelIdEqualTo(Integer value) {
            addCriterion("model_id =", value, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdNotEqualTo(Integer value) {
            addCriterion("model_id <>", value, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdGreaterThan(Integer value) {
            addCriterion("model_id >", value, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("model_id >=", value, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdLessThan(Integer value) {
            addCriterion("model_id <", value, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdLessThanOrEqualTo(Integer value) {
            addCriterion("model_id <=", value, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdIn(List<Integer> values) {
            addCriterion("model_id in", values, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdNotIn(List<Integer> values) {
            addCriterion("model_id not in", values, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdBetween(Integer value1, Integer value2) {
            addCriterion("model_id between", value1, value2, "modelId");
            return (Criteria) this;
        }

        public Criteria andModelIdNotBetween(Integer value1, Integer value2) {
            addCriterion("model_id not between", value1, value2, "modelId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdIsNull() {
            addCriterion("series_id is null");
            return (Criteria) this;
        }

        public Criteria andSeriesIdIsNotNull() {
            addCriterion("series_id is not null");
            return (Criteria) this;
        }

        public Criteria andSeriesIdEqualTo(Integer value) {
            addCriterion("series_id =", value, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdNotEqualTo(Integer value) {
            addCriterion("series_id <>", value, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdGreaterThan(Integer value) {
            addCriterion("series_id >", value, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("series_id >=", value, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdLessThan(Integer value) {
            addCriterion("series_id <", value, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdLessThanOrEqualTo(Integer value) {
            addCriterion("series_id <=", value, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdIn(List<Integer> values) {
            addCriterion("series_id in", values, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdNotIn(List<Integer> values) {
            addCriterion("series_id not in", values, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdBetween(Integer value1, Integer value2) {
            addCriterion("series_id between", value1, value2, "seriesId");
            return (Criteria) this;
        }

        public Criteria andSeriesIdNotBetween(Integer value1, Integer value2) {
            addCriterion("series_id not between", value1, value2, "seriesId");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNull() {
            addCriterion("brand_id is null");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNotNull() {
            addCriterion("brand_id is not null");
            return (Criteria) this;
        }

        public Criteria andBrandIdEqualTo(Integer value) {
            addCriterion("brand_id =", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotEqualTo(Integer value) {
            addCriterion("brand_id <>", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThan(Integer value) {
            addCriterion("brand_id >", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("brand_id >=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThan(Integer value) {
            addCriterion("brand_id <", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThanOrEqualTo(Integer value) {
            addCriterion("brand_id <=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdIn(List<Integer> values) {
            addCriterion("brand_id in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotIn(List<Integer> values) {
            addCriterion("brand_id not in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdBetween(Integer value1, Integer value2) {
            addCriterion("brand_id between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotBetween(Integer value1, Integer value2) {
            addCriterion("brand_id not between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andManufacturerIdIsNull() {
            addCriterion("manufacturer_id is null");
            return (Criteria) this;
        }

        public Criteria andManufacturerIdIsNotNull() {
            addCriterion("manufacturer_id is not null");
            return (Criteria) this;
        }

        public Criteria andManufacturerIdEqualTo(Integer value) {
            addCriterion("manufacturer_id =", value, "manufacturerId");
            return (Criteria) this;
        }

        public Criteria andManufacturerIdNotEqualTo(Integer value) {
            addCriterion("manufacturer_id <>", value, "manufacturerId");
            return (Criteria) this;
        }

        public Criteria andManufacturerIdGreaterThan(Integer value) {
            addCriterion("manufacturer_id >", value, "manufacturerId");
            return (Criteria) this;
        }

        public Criteria andManufacturerIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("manufacturer_id >=", value, "manufacturerId");
            return (Criteria) this;
        }

        public Criteria andManufacturerIdLessThan(Integer value) {
            addCriterion("manufacturer_id <", value, "manufacturerId");
            return (Criteria) this;
        }

        public Criteria andManufacturerIdLessThanOrEqualTo(Integer value) {
            addCriterion("manufacturer_id <=", value, "manufacturerId");
            return (Criteria) this;
        }

        public Criteria andManufacturerIdIn(List<Integer> values) {
            addCriterion("manufacturer_id in", values, "manufacturerId");
            return (Criteria) this;
        }

        public Criteria andManufacturerIdNotIn(List<Integer> values) {
            addCriterion("manufacturer_id not in", values, "manufacturerId");
            return (Criteria) this;
        }

        public Criteria andManufacturerIdBetween(Integer value1, Integer value2) {
            addCriterion("manufacturer_id between", value1, value2, "manufacturerId");
            return (Criteria) this;
        }

        public Criteria andManufacturerIdNotBetween(Integer value1, Integer value2) {
            addCriterion("manufacturer_id not between", value1, value2, "manufacturerId");
            return (Criteria) this;
        }

        public Criteria andEngineNoIsNull() {
            addCriterion("engine_no is null");
            return (Criteria) this;
        }

        public Criteria andEngineNoIsNotNull() {
            addCriterion("engine_no is not null");
            return (Criteria) this;
        }

        public Criteria andEngineNoEqualTo(String value) {
            addCriterion("engine_no =", value, "engineNo");
            return (Criteria) this;
        }

        public Criteria andEngineNoNotEqualTo(String value) {
            addCriterion("engine_no <>", value, "engineNo");
            return (Criteria) this;
        }

        public Criteria andEngineNoGreaterThan(String value) {
            addCriterion("engine_no >", value, "engineNo");
            return (Criteria) this;
        }

        public Criteria andEngineNoGreaterThanOrEqualTo(String value) {
            addCriterion("engine_no >=", value, "engineNo");
            return (Criteria) this;
        }

        public Criteria andEngineNoLessThan(String value) {
            addCriterion("engine_no <", value, "engineNo");
            return (Criteria) this;
        }

        public Criteria andEngineNoLessThanOrEqualTo(String value) {
            addCriterion("engine_no <=", value, "engineNo");
            return (Criteria) this;
        }

        public Criteria andEngineNoLike(String value) {
            addCriterion("engine_no like", value, "engineNo");
            return (Criteria) this;
        }

        public Criteria andEngineNoNotLike(String value) {
            addCriterion("engine_no not like", value, "engineNo");
            return (Criteria) this;
        }

        public Criteria andEngineNoIn(List<String> values) {
            addCriterion("engine_no in", values, "engineNo");
            return (Criteria) this;
        }

        public Criteria andEngineNoNotIn(List<String> values) {
            addCriterion("engine_no not in", values, "engineNo");
            return (Criteria) this;
        }

        public Criteria andEngineNoBetween(String value1, String value2) {
            addCriterion("engine_no between", value1, value2, "engineNo");
            return (Criteria) this;
        }

        public Criteria andEngineNoNotBetween(String value1, String value2) {
            addCriterion("engine_no not between", value1, value2, "engineNo");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateIsNull() {
            addCriterion("purchase_date is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateIsNotNull() {
            addCriterion("purchase_date is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateEqualTo(Date value) {
            addCriterion("purchase_date =", value, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateNotEqualTo(Date value) {
            addCriterion("purchase_date <>", value, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateGreaterThan(Date value) {
            addCriterion("purchase_date >", value, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateGreaterThanOrEqualTo(Date value) {
            addCriterion("purchase_date >=", value, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateLessThan(Date value) {
            addCriterion("purchase_date <", value, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateLessThanOrEqualTo(Date value) {
            addCriterion("purchase_date <=", value, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateIn(List<Date> values) {
            addCriterion("purchase_date in", values, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateNotIn(List<Date> values) {
            addCriterion("purchase_date not in", values, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateBetween(Date value1, Date value2) {
            addCriterion("purchase_date between", value1, value2, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateNotBetween(Date value1, Date value2) {
            addCriterion("purchase_date not between", value1, value2, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andProductionDateIsNull() {
            addCriterion("production_date is null");
            return (Criteria) this;
        }

        public Criteria andProductionDateIsNotNull() {
            addCriterion("production_date is not null");
            return (Criteria) this;
        }

        public Criteria andProductionDateEqualTo(Date value) {
            addCriterion("production_date =", value, "productionDate");
            return (Criteria) this;
        }

        public Criteria andProductionDateNotEqualTo(Date value) {
            addCriterion("production_date <>", value, "productionDate");
            return (Criteria) this;
        }

        public Criteria andProductionDateGreaterThan(Date value) {
            addCriterion("production_date >", value, "productionDate");
            return (Criteria) this;
        }

        public Criteria andProductionDateGreaterThanOrEqualTo(Date value) {
            addCriterion("production_date >=", value, "productionDate");
            return (Criteria) this;
        }

        public Criteria andProductionDateLessThan(Date value) {
            addCriterion("production_date <", value, "productionDate");
            return (Criteria) this;
        }

        public Criteria andProductionDateLessThanOrEqualTo(Date value) {
            addCriterion("production_date <=", value, "productionDate");
            return (Criteria) this;
        }

        public Criteria andProductionDateIn(List<Date> values) {
            addCriterion("production_date in", values, "productionDate");
            return (Criteria) this;
        }

        public Criteria andProductionDateNotIn(List<Date> values) {
            addCriterion("production_date not in", values, "productionDate");
            return (Criteria) this;
        }

        public Criteria andProductionDateBetween(Date value1, Date value2) {
            addCriterion("production_date between", value1, value2, "productionDate");
            return (Criteria) this;
        }

        public Criteria andProductionDateNotBetween(Date value1, Date value2) {
            addCriterion("production_date not between", value1, value2, "productionDate");
            return (Criteria) this;
        }

        public Criteria andOwnerNameIsNull() {
            addCriterion("owner_name is null");
            return (Criteria) this;
        }

        public Criteria andOwnerNameIsNotNull() {
            addCriterion("owner_name is not null");
            return (Criteria) this;
        }

        public Criteria andOwnerNameEqualTo(String value) {
            addCriterion("owner_name =", value, "ownerName");
            return (Criteria) this;
        }

        public Criteria andOwnerNameNotEqualTo(String value) {
            addCriterion("owner_name <>", value, "ownerName");
            return (Criteria) this;
        }

        public Criteria andOwnerNameGreaterThan(String value) {
            addCriterion("owner_name >", value, "ownerName");
            return (Criteria) this;
        }

        public Criteria andOwnerNameGreaterThanOrEqualTo(String value) {
            addCriterion("owner_name >=", value, "ownerName");
            return (Criteria) this;
        }

        public Criteria andOwnerNameLessThan(String value) {
            addCriterion("owner_name <", value, "ownerName");
            return (Criteria) this;
        }

        public Criteria andOwnerNameLessThanOrEqualTo(String value) {
            addCriterion("owner_name <=", value, "ownerName");
            return (Criteria) this;
        }

        public Criteria andOwnerNameLike(String value) {
            addCriterion("owner_name like", value, "ownerName");
            return (Criteria) this;
        }

        public Criteria andOwnerNameNotLike(String value) {
            addCriterion("owner_name not like", value, "ownerName");
            return (Criteria) this;
        }

        public Criteria andOwnerNameIn(List<String> values) {
            addCriterion("owner_name in", values, "ownerName");
            return (Criteria) this;
        }

        public Criteria andOwnerNameNotIn(List<String> values) {
            addCriterion("owner_name not in", values, "ownerName");
            return (Criteria) this;
        }

        public Criteria andOwnerNameBetween(String value1, String value2) {
            addCriterion("owner_name between", value1, value2, "ownerName");
            return (Criteria) this;
        }

        public Criteria andOwnerNameNotBetween(String value1, String value2) {
            addCriterion("owner_name not between", value1, value2, "ownerName");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andModelNameIsNull() {
            addCriterion("model_name is null");
            return (Criteria) this;
        }

        public Criteria andModelNameIsNotNull() {
            addCriterion("model_name is not null");
            return (Criteria) this;
        }

        public Criteria andModelNameEqualTo(String value) {
            addCriterion("model_name =", value, "modelName");
            return (Criteria) this;
        }

        public Criteria andModelNameNotEqualTo(String value) {
            addCriterion("model_name <>", value, "modelName");
            return (Criteria) this;
        }

        public Criteria andModelNameGreaterThan(String value) {
            addCriterion("model_name >", value, "modelName");
            return (Criteria) this;
        }

        public Criteria andModelNameGreaterThanOrEqualTo(String value) {
            addCriterion("model_name >=", value, "modelName");
            return (Criteria) this;
        }

        public Criteria andModelNameLessThan(String value) {
            addCriterion("model_name <", value, "modelName");
            return (Criteria) this;
        }

        public Criteria andModelNameLessThanOrEqualTo(String value) {
            addCriterion("model_name <=", value, "modelName");
            return (Criteria) this;
        }

        public Criteria andModelNameLike(String value) {
            addCriterion("model_name like", value, "modelName");
            return (Criteria) this;
        }

        public Criteria andModelNameNotLike(String value) {
            addCriterion("model_name not like", value, "modelName");
            return (Criteria) this;
        }

        public Criteria andModelNameIn(List<String> values) {
            addCriterion("model_name in", values, "modelName");
            return (Criteria) this;
        }

        public Criteria andModelNameNotIn(List<String> values) {
            addCriterion("model_name not in", values, "modelName");
            return (Criteria) this;
        }

        public Criteria andModelNameBetween(String value1, String value2) {
            addCriterion("model_name between", value1, value2, "modelName");
            return (Criteria) this;
        }

        public Criteria andModelNameNotBetween(String value1, String value2) {
            addCriterion("model_name not between", value1, value2, "modelName");
            return (Criteria) this;
        }

        public Criteria andBrandNameIsNull() {
            addCriterion("brand_name is null");
            return (Criteria) this;
        }

        public Criteria andBrandNameIsNotNull() {
            addCriterion("brand_name is not null");
            return (Criteria) this;
        }

        public Criteria andBrandNameEqualTo(String value) {
            addCriterion("brand_name =", value, "brandName");
            return (Criteria) this;
        }

        public Criteria andBrandNameNotEqualTo(String value) {
            addCriterion("brand_name <>", value, "brandName");
            return (Criteria) this;
        }

        public Criteria andBrandNameGreaterThan(String value) {
            addCriterion("brand_name >", value, "brandName");
            return (Criteria) this;
        }

        public Criteria andBrandNameGreaterThanOrEqualTo(String value) {
            addCriterion("brand_name >=", value, "brandName");
            return (Criteria) this;
        }

        public Criteria andBrandNameLessThan(String value) {
            addCriterion("brand_name <", value, "brandName");
            return (Criteria) this;
        }

        public Criteria andBrandNameLessThanOrEqualTo(String value) {
            addCriterion("brand_name <=", value, "brandName");
            return (Criteria) this;
        }

        public Criteria andBrandNameLike(String value) {
            addCriterion("brand_name like", value, "brandName");
            return (Criteria) this;
        }

        public Criteria andBrandNameNotLike(String value) {
            addCriterion("brand_name not like", value, "brandName");
            return (Criteria) this;
        }

        public Criteria andBrandNameIn(List<String> values) {
            addCriterion("brand_name in", values, "brandName");
            return (Criteria) this;
        }

        public Criteria andBrandNameNotIn(List<String> values) {
            addCriterion("brand_name not in", values, "brandName");
            return (Criteria) this;
        }

        public Criteria andBrandNameBetween(String value1, String value2) {
            addCriterion("brand_name between", value1, value2, "brandName");
            return (Criteria) this;
        }

        public Criteria andBrandNameNotBetween(String value1, String value2) {
            addCriterion("brand_name not between", value1, value2, "brandName");
            return (Criteria) this;
        }

        public Criteria andOwnerTelIsNull() {
            addCriterion("owner_tel is null");
            return (Criteria) this;
        }

        public Criteria andOwnerTelIsNotNull() {
            addCriterion("owner_tel is not null");
            return (Criteria) this;
        }

        public Criteria andOwnerTelEqualTo(String value) {
            addCriterion("owner_tel =", value, "ownerTel");
            return (Criteria) this;
        }

        public Criteria andOwnerTelNotEqualTo(String value) {
            addCriterion("owner_tel <>", value, "ownerTel");
            return (Criteria) this;
        }

        public Criteria andOwnerTelGreaterThan(String value) {
            addCriterion("owner_tel >", value, "ownerTel");
            return (Criteria) this;
        }

        public Criteria andOwnerTelGreaterThanOrEqualTo(String value) {
            addCriterion("owner_tel >=", value, "ownerTel");
            return (Criteria) this;
        }

        public Criteria andOwnerTelLessThan(String value) {
            addCriterion("owner_tel <", value, "ownerTel");
            return (Criteria) this;
        }

        public Criteria andOwnerTelLessThanOrEqualTo(String value) {
            addCriterion("owner_tel <=", value, "ownerTel");
            return (Criteria) this;
        }

        public Criteria andOwnerTelLike(String value) {
            addCriterion("owner_tel like", value, "ownerTel");
            return (Criteria) this;
        }

        public Criteria andOwnerTelNotLike(String value) {
            addCriterion("owner_tel not like", value, "ownerTel");
            return (Criteria) this;
        }

        public Criteria andOwnerTelIn(List<String> values) {
            addCriterion("owner_tel in", values, "ownerTel");
            return (Criteria) this;
        }

        public Criteria andOwnerTelNotIn(List<String> values) {
            addCriterion("owner_tel not in", values, "ownerTel");
            return (Criteria) this;
        }

        public Criteria andOwnerTelBetween(String value1, String value2) {
            addCriterion("owner_tel between", value1, value2, "ownerTel");
            return (Criteria) this;
        }

        public Criteria andOwnerTelNotBetween(String value1, String value2) {
            addCriterion("owner_tel not between", value1, value2, "ownerTel");
            return (Criteria) this;
        }

        public Criteria andInstallStoreidIsNull() {
            addCriterion("install_storeid is null");
            return (Criteria) this;
        }

        public Criteria andInstallStoreidIsNotNull() {
            addCriterion("install_storeid is not null");
            return (Criteria) this;
        }

        public Criteria andInstallStoreidEqualTo(String value) {
            addCriterion("install_storeid =", value, "installStoreid");
            return (Criteria) this;
        }

        public Criteria andInstallStoreidNotEqualTo(String value) {
            addCriterion("install_storeid <>", value, "installStoreid");
            return (Criteria) this;
        }

        public Criteria andInstallStoreidGreaterThan(String value) {
            addCriterion("install_storeid >", value, "installStoreid");
            return (Criteria) this;
        }

        public Criteria andInstallStoreidGreaterThanOrEqualTo(String value) {
            addCriterion("install_storeid >=", value, "installStoreid");
            return (Criteria) this;
        }

        public Criteria andInstallStoreidLessThan(String value) {
            addCriterion("install_storeid <", value, "installStoreid");
            return (Criteria) this;
        }

        public Criteria andInstallStoreidLessThanOrEqualTo(String value) {
            addCriterion("install_storeid <=", value, "installStoreid");
            return (Criteria) this;
        }

        public Criteria andInstallStoreidLike(String value) {
            addCriterion("install_storeid like", value, "installStoreid");
            return (Criteria) this;
        }

        public Criteria andInstallStoreidNotLike(String value) {
            addCriterion("install_storeid not like", value, "installStoreid");
            return (Criteria) this;
        }

        public Criteria andInstallStoreidIn(List<String> values) {
            addCriterion("install_storeid in", values, "installStoreid");
            return (Criteria) this;
        }

        public Criteria andInstallStoreidNotIn(List<String> values) {
            addCriterion("install_storeid not in", values, "installStoreid");
            return (Criteria) this;
        }

        public Criteria andInstallStoreidBetween(String value1, String value2) {
            addCriterion("install_storeid between", value1, value2, "installStoreid");
            return (Criteria) this;
        }

        public Criteria andInstallStoreidNotBetween(String value1, String value2) {
            addCriterion("install_storeid not between", value1, value2, "installStoreid");
            return (Criteria) this;
        }

        public Criteria andInstallStorenameIsNull() {
            addCriterion("install_storename is null");
            return (Criteria) this;
        }

        public Criteria andInstallStorenameIsNotNull() {
            addCriterion("install_storename is not null");
            return (Criteria) this;
        }

        public Criteria andInstallStorenameEqualTo(String value) {
            addCriterion("install_storename =", value, "installStorename");
            return (Criteria) this;
        }

        public Criteria andInstallStorenameNotEqualTo(String value) {
            addCriterion("install_storename <>", value, "installStorename");
            return (Criteria) this;
        }

        public Criteria andInstallStorenameGreaterThan(String value) {
            addCriterion("install_storename >", value, "installStorename");
            return (Criteria) this;
        }

        public Criteria andInstallStorenameGreaterThanOrEqualTo(String value) {
            addCriterion("install_storename >=", value, "installStorename");
            return (Criteria) this;
        }

        public Criteria andInstallStorenameLessThan(String value) {
            addCriterion("install_storename <", value, "installStorename");
            return (Criteria) this;
        }

        public Criteria andInstallStorenameLessThanOrEqualTo(String value) {
            addCriterion("install_storename <=", value, "installStorename");
            return (Criteria) this;
        }

        public Criteria andInstallStorenameLike(String value) {
            addCriterion("install_storename like", value, "installStorename");
            return (Criteria) this;
        }

        public Criteria andInstallStorenameNotLike(String value) {
            addCriterion("install_storename not like", value, "installStorename");
            return (Criteria) this;
        }

        public Criteria andInstallStorenameIn(List<String> values) {
            addCriterion("install_storename in", values, "installStorename");
            return (Criteria) this;
        }

        public Criteria andInstallStorenameNotIn(List<String> values) {
            addCriterion("install_storename not in", values, "installStorename");
            return (Criteria) this;
        }

        public Criteria andInstallStorenameBetween(String value1, String value2) {
            addCriterion("install_storename between", value1, value2, "installStorename");
            return (Criteria) this;
        }

        public Criteria andInstallStorenameNotBetween(String value1, String value2) {
            addCriterion("install_storename not between", value1, value2, "installStorename");
            return (Criteria) this;
        }

        public Criteria andIsSendlistIsNull() {
            addCriterion("is_sendlist is null");
            return (Criteria) this;
        }

        public Criteria andIsSendlistIsNotNull() {
            addCriterion("is_sendlist is not null");
            return (Criteria) this;
        }

        public Criteria andIsSendlistEqualTo(Integer value) {
            addCriterion("is_sendlist =", value, "isSendlist");
            return (Criteria) this;
        }

        public Criteria andIsSendlistNotEqualTo(Integer value) {
            addCriterion("is_sendlist <>", value, "isSendlist");
            return (Criteria) this;
        }

        public Criteria andIsSendlistGreaterThan(Integer value) {
            addCriterion("is_sendlist >", value, "isSendlist");
            return (Criteria) this;
        }

        public Criteria andIsSendlistGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_sendlist >=", value, "isSendlist");
            return (Criteria) this;
        }

        public Criteria andIsSendlistLessThan(Integer value) {
            addCriterion("is_sendlist <", value, "isSendlist");
            return (Criteria) this;
        }

        public Criteria andIsSendlistLessThanOrEqualTo(Integer value) {
            addCriterion("is_sendlist <=", value, "isSendlist");
            return (Criteria) this;
        }

        public Criteria andIsSendlistIn(List<Integer> values) {
            addCriterion("is_sendlist in", values, "isSendlist");
            return (Criteria) this;
        }

        public Criteria andIsSendlistNotIn(List<Integer> values) {
            addCriterion("is_sendlist not in", values, "isSendlist");
            return (Criteria) this;
        }

        public Criteria andIsSendlistBetween(Integer value1, Integer value2) {
            addCriterion("is_sendlist between", value1, value2, "isSendlist");
            return (Criteria) this;
        }

        public Criteria andIsSendlistNotBetween(Integer value1, Integer value2) {
            addCriterion("is_sendlist not between", value1, value2, "isSendlist");
            return (Criteria) this;
        }

        public Criteria andSendlistCompanynameIsNull() {
            addCriterion("sendlist_companyname is null");
            return (Criteria) this;
        }

        public Criteria andSendlistCompanynameIsNotNull() {
            addCriterion("sendlist_companyname is not null");
            return (Criteria) this;
        }

        public Criteria andSendlistCompanynameEqualTo(String value) {
            addCriterion("sendlist_companyname =", value, "sendlistCompanyname");
            return (Criteria) this;
        }

        public Criteria andSendlistCompanynameNotEqualTo(String value) {
            addCriterion("sendlist_companyname <>", value, "sendlistCompanyname");
            return (Criteria) this;
        }

        public Criteria andSendlistCompanynameGreaterThan(String value) {
            addCriterion("sendlist_companyname >", value, "sendlistCompanyname");
            return (Criteria) this;
        }

        public Criteria andSendlistCompanynameGreaterThanOrEqualTo(String value) {
            addCriterion("sendlist_companyname >=", value, "sendlistCompanyname");
            return (Criteria) this;
        }

        public Criteria andSendlistCompanynameLessThan(String value) {
            addCriterion("sendlist_companyname <", value, "sendlistCompanyname");
            return (Criteria) this;
        }

        public Criteria andSendlistCompanynameLessThanOrEqualTo(String value) {
            addCriterion("sendlist_companyname <=", value, "sendlistCompanyname");
            return (Criteria) this;
        }

        public Criteria andSendlistCompanynameLike(String value) {
            addCriterion("sendlist_companyname like", value, "sendlistCompanyname");
            return (Criteria) this;
        }

        public Criteria andSendlistCompanynameNotLike(String value) {
            addCriterion("sendlist_companyname not like", value, "sendlistCompanyname");
            return (Criteria) this;
        }

        public Criteria andSendlistCompanynameIn(List<String> values) {
            addCriterion("sendlist_companyname in", values, "sendlistCompanyname");
            return (Criteria) this;
        }

        public Criteria andSendlistCompanynameNotIn(List<String> values) {
            addCriterion("sendlist_companyname not in", values, "sendlistCompanyname");
            return (Criteria) this;
        }

        public Criteria andSendlistCompanynameBetween(String value1, String value2) {
            addCriterion("sendlist_companyname between", value1, value2, "sendlistCompanyname");
            return (Criteria) this;
        }

        public Criteria andSendlistCompanynameNotBetween(String value1, String value2) {
            addCriterion("sendlist_companyname not between", value1, value2, "sendlistCompanyname");
            return (Criteria) this;
        }

        public Criteria andPreInstalladdressIsNull() {
            addCriterion("pre_installaddress is null");
            return (Criteria) this;
        }

        public Criteria andPreInstalladdressIsNotNull() {
            addCriterion("pre_installaddress is not null");
            return (Criteria) this;
        }

        public Criteria andPreInstalladdressEqualTo(String value) {
            addCriterion("pre_installaddress =", value, "preInstalladdress");
            return (Criteria) this;
        }

        public Criteria andPreInstalladdressNotEqualTo(String value) {
            addCriterion("pre_installaddress <>", value, "preInstalladdress");
            return (Criteria) this;
        }

        public Criteria andPreInstalladdressGreaterThan(String value) {
            addCriterion("pre_installaddress >", value, "preInstalladdress");
            return (Criteria) this;
        }

        public Criteria andPreInstalladdressGreaterThanOrEqualTo(String value) {
            addCriterion("pre_installaddress >=", value, "preInstalladdress");
            return (Criteria) this;
        }

        public Criteria andPreInstalladdressLessThan(String value) {
            addCriterion("pre_installaddress <", value, "preInstalladdress");
            return (Criteria) this;
        }

        public Criteria andPreInstalladdressLessThanOrEqualTo(String value) {
            addCriterion("pre_installaddress <=", value, "preInstalladdress");
            return (Criteria) this;
        }

        public Criteria andPreInstalladdressLike(String value) {
            addCriterion("pre_installaddress like", value, "preInstalladdress");
            return (Criteria) this;
        }

        public Criteria andPreInstalladdressNotLike(String value) {
            addCriterion("pre_installaddress not like", value, "preInstalladdress");
            return (Criteria) this;
        }

        public Criteria andPreInstalladdressIn(List<String> values) {
            addCriterion("pre_installaddress in", values, "preInstalladdress");
            return (Criteria) this;
        }

        public Criteria andPreInstalladdressNotIn(List<String> values) {
            addCriterion("pre_installaddress not in", values, "preInstalladdress");
            return (Criteria) this;
        }

        public Criteria andPreInstalladdressBetween(String value1, String value2) {
            addCriterion("pre_installaddress between", value1, value2, "preInstalladdress");
            return (Criteria) this;
        }

        public Criteria andPreInstalladdressNotBetween(String value1, String value2) {
            addCriterion("pre_installaddress not between", value1, value2, "preInstalladdress");
            return (Criteria) this;
        }

        public Criteria andPreLinkmanIsNull() {
            addCriterion("pre_linkman is null");
            return (Criteria) this;
        }

        public Criteria andPreLinkmanIsNotNull() {
            addCriterion("pre_linkman is not null");
            return (Criteria) this;
        }

        public Criteria andPreLinkmanEqualTo(String value) {
            addCriterion("pre_linkman =", value, "preLinkman");
            return (Criteria) this;
        }

        public Criteria andPreLinkmanNotEqualTo(String value) {
            addCriterion("pre_linkman <>", value, "preLinkman");
            return (Criteria) this;
        }

        public Criteria andPreLinkmanGreaterThan(String value) {
            addCriterion("pre_linkman >", value, "preLinkman");
            return (Criteria) this;
        }

        public Criteria andPreLinkmanGreaterThanOrEqualTo(String value) {
            addCriterion("pre_linkman >=", value, "preLinkman");
            return (Criteria) this;
        }

        public Criteria andPreLinkmanLessThan(String value) {
            addCriterion("pre_linkman <", value, "preLinkman");
            return (Criteria) this;
        }

        public Criteria andPreLinkmanLessThanOrEqualTo(String value) {
            addCriterion("pre_linkman <=", value, "preLinkman");
            return (Criteria) this;
        }

        public Criteria andPreLinkmanLike(String value) {
            addCriterion("pre_linkman like", value, "preLinkman");
            return (Criteria) this;
        }

        public Criteria andPreLinkmanNotLike(String value) {
            addCriterion("pre_linkman not like", value, "preLinkman");
            return (Criteria) this;
        }

        public Criteria andPreLinkmanIn(List<String> values) {
            addCriterion("pre_linkman in", values, "preLinkman");
            return (Criteria) this;
        }

        public Criteria andPreLinkmanNotIn(List<String> values) {
            addCriterion("pre_linkman not in", values, "preLinkman");
            return (Criteria) this;
        }

        public Criteria andPreLinkmanBetween(String value1, String value2) {
            addCriterion("pre_linkman between", value1, value2, "preLinkman");
            return (Criteria) this;
        }

        public Criteria andPreLinkmanNotBetween(String value1, String value2) {
            addCriterion("pre_linkman not between", value1, value2, "preLinkman");
            return (Criteria) this;
        }

        public Criteria andPreLinktelIsNull() {
            addCriterion("pre_linktel is null");
            return (Criteria) this;
        }

        public Criteria andPreLinktelIsNotNull() {
            addCriterion("pre_linktel is not null");
            return (Criteria) this;
        }

        public Criteria andPreLinktelEqualTo(String value) {
            addCriterion("pre_linktel =", value, "preLinktel");
            return (Criteria) this;
        }

        public Criteria andPreLinktelNotEqualTo(String value) {
            addCriterion("pre_linktel <>", value, "preLinktel");
            return (Criteria) this;
        }

        public Criteria andPreLinktelGreaterThan(String value) {
            addCriterion("pre_linktel >", value, "preLinktel");
            return (Criteria) this;
        }

        public Criteria andPreLinktelGreaterThanOrEqualTo(String value) {
            addCriterion("pre_linktel >=", value, "preLinktel");
            return (Criteria) this;
        }

        public Criteria andPreLinktelLessThan(String value) {
            addCriterion("pre_linktel <", value, "preLinktel");
            return (Criteria) this;
        }

        public Criteria andPreLinktelLessThanOrEqualTo(String value) {
            addCriterion("pre_linktel <=", value, "preLinktel");
            return (Criteria) this;
        }

        public Criteria andPreLinktelLike(String value) {
            addCriterion("pre_linktel like", value, "preLinktel");
            return (Criteria) this;
        }

        public Criteria andPreLinktelNotLike(String value) {
            addCriterion("pre_linktel not like", value, "preLinktel");
            return (Criteria) this;
        }

        public Criteria andPreLinktelIn(List<String> values) {
            addCriterion("pre_linktel in", values, "preLinktel");
            return (Criteria) this;
        }

        public Criteria andPreLinktelNotIn(List<String> values) {
            addCriterion("pre_linktel not in", values, "preLinktel");
            return (Criteria) this;
        }

        public Criteria andPreLinktelBetween(String value1, String value2) {
            addCriterion("pre_linktel between", value1, value2, "preLinktel");
            return (Criteria) this;
        }

        public Criteria andPreLinktelNotBetween(String value1, String value2) {
            addCriterion("pre_linktel not between", value1, value2, "preLinktel");
            return (Criteria) this;
        }

        public Criteria andPreInstalltimeIsNull() {
            addCriterion("pre_installtime is null");
            return (Criteria) this;
        }

        public Criteria andPreInstalltimeIsNotNull() {
            addCriterion("pre_installtime is not null");
            return (Criteria) this;
        }

        public Criteria andPreInstalltimeEqualTo(Date value) {
            addCriterion("pre_installtime =", value, "preInstalltime");
            return (Criteria) this;
        }

        public Criteria andPreInstalltimeNotEqualTo(Date value) {
            addCriterion("pre_installtime <>", value, "preInstalltime");
            return (Criteria) this;
        }

        public Criteria andPreInstalltimeGreaterThan(Date value) {
            addCriterion("pre_installtime >", value, "preInstalltime");
            return (Criteria) this;
        }

        public Criteria andPreInstalltimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pre_installtime >=", value, "preInstalltime");
            return (Criteria) this;
        }

        public Criteria andPreInstalltimeLessThan(Date value) {
            addCriterion("pre_installtime <", value, "preInstalltime");
            return (Criteria) this;
        }

        public Criteria andPreInstalltimeLessThanOrEqualTo(Date value) {
            addCriterion("pre_installtime <=", value, "preInstalltime");
            return (Criteria) this;
        }

        public Criteria andPreInstalltimeIn(List<Date> values) {
            addCriterion("pre_installtime in", values, "preInstalltime");
            return (Criteria) this;
        }

        public Criteria andPreInstalltimeNotIn(List<Date> values) {
            addCriterion("pre_installtime not in", values, "preInstalltime");
            return (Criteria) this;
        }

        public Criteria andPreInstalltimeBetween(Date value1, Date value2) {
            addCriterion("pre_installtime between", value1, value2, "preInstalltime");
            return (Criteria) this;
        }

        public Criteria andPreInstalltimeNotBetween(Date value1, Date value2) {
            addCriterion("pre_installtime not between", value1, value2, "preInstalltime");
            return (Criteria) this;
        }

        public Criteria andInstallNumberIsNull() {
            addCriterion("install_number is null");
            return (Criteria) this;
        }

        public Criteria andInstallNumberIsNotNull() {
            addCriterion("install_number is not null");
            return (Criteria) this;
        }

        public Criteria andInstallNumberEqualTo(String value) {
            addCriterion("install_number =", value, "installNumber");
            return (Criteria) this;
        }

        public Criteria andInstallNumberNotEqualTo(String value) {
            addCriterion("install_number <>", value, "installNumber");
            return (Criteria) this;
        }

        public Criteria andInstallNumberGreaterThan(String value) {
            addCriterion("install_number >", value, "installNumber");
            return (Criteria) this;
        }

        public Criteria andInstallNumberGreaterThanOrEqualTo(String value) {
            addCriterion("install_number >=", value, "installNumber");
            return (Criteria) this;
        }

        public Criteria andInstallNumberLessThan(String value) {
            addCriterion("install_number <", value, "installNumber");
            return (Criteria) this;
        }

        public Criteria andInstallNumberLessThanOrEqualTo(String value) {
            addCriterion("install_number <=", value, "installNumber");
            return (Criteria) this;
        }

        public Criteria andInstallNumberLike(String value) {
            addCriterion("install_number like", value, "installNumber");
            return (Criteria) this;
        }

        public Criteria andInstallNumberNotLike(String value) {
            addCriterion("install_number not like", value, "installNumber");
            return (Criteria) this;
        }

        public Criteria andInstallNumberIn(List<String> values) {
            addCriterion("install_number in", values, "installNumber");
            return (Criteria) this;
        }

        public Criteria andInstallNumberNotIn(List<String> values) {
            addCriterion("install_number not in", values, "installNumber");
            return (Criteria) this;
        }

        public Criteria andInstallNumberBetween(String value1, String value2) {
            addCriterion("install_number between", value1, value2, "installNumber");
            return (Criteria) this;
        }

        public Criteria andInstallNumberNotBetween(String value1, String value2) {
            addCriterion("install_number not between", value1, value2, "installNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberIsNull() {
            addCriterion("product_number is null");
            return (Criteria) this;
        }

        public Criteria andProductNumberIsNotNull() {
            addCriterion("product_number is not null");
            return (Criteria) this;
        }

        public Criteria andProductNumberEqualTo(String value) {
            addCriterion("product_number =", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberNotEqualTo(String value) {
            addCriterion("product_number <>", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberGreaterThan(String value) {
            addCriterion("product_number >", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberGreaterThanOrEqualTo(String value) {
            addCriterion("product_number >=", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberLessThan(String value) {
            addCriterion("product_number <", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberLessThanOrEqualTo(String value) {
            addCriterion("product_number <=", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberLike(String value) {
            addCriterion("product_number like", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberNotLike(String value) {
            addCriterion("product_number not like", value, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberIn(List<String> values) {
            addCriterion("product_number in", values, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberNotIn(List<String> values) {
            addCriterion("product_number not in", values, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberBetween(String value1, String value2) {
            addCriterion("product_number between", value1, value2, "productNumber");
            return (Criteria) this;
        }

        public Criteria andProductNumberNotBetween(String value1, String value2) {
            addCriterion("product_number not between", value1, value2, "productNumber");
            return (Criteria) this;
        }

        public Criteria andDataStateIsNull() {
            addCriterion("data_state is null");
            return (Criteria) this;
        }

        public Criteria andDataStateIsNotNull() {
            addCriterion("data_state is not null");
            return (Criteria) this;
        }

        public Criteria andDataStateEqualTo(Byte value) {
            addCriterion("data_state =", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateNotEqualTo(Byte value) {
            addCriterion("data_state <>", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateGreaterThan(Byte value) {
            addCriterion("data_state >", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateGreaterThanOrEqualTo(Byte value) {
            addCriterion("data_state >=", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateLessThan(Byte value) {
            addCriterion("data_state <", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateLessThanOrEqualTo(Byte value) {
            addCriterion("data_state <=", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateIn(List<Byte> values) {
            addCriterion("data_state in", values, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateNotIn(List<Byte> values) {
            addCriterion("data_state not in", values, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateBetween(Byte value1, Byte value2) {
            addCriterion("data_state between", value1, value2, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateNotBetween(Byte value1, Byte value2) {
            addCriterion("data_state not between", value1, value2, "dataState");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNull() {
            addCriterion("end_time is null");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNotNull() {
            addCriterion("end_time is not null");
            return (Criteria) this;
        }

        public Criteria andEndTimeEqualTo(Date value) {
            addCriterion("end_time =", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotEqualTo(Date value) {
            addCriterion("end_time <>", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThan(Date value) {
            addCriterion("end_time >", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("end_time >=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThan(Date value) {
            addCriterion("end_time <", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("end_time <=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIn(List<Date> values) {
            addCriterion("end_time in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotIn(List<Date> values) {
            addCriterion("end_time not in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeBetween(Date value1, Date value2) {
            addCriterion("end_time between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("end_time not between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andOwnerIdcardIsNull() {
            addCriterion("owner_idcard is null");
            return (Criteria) this;
        }

        public Criteria andOwnerIdcardIsNotNull() {
            addCriterion("owner_idcard is not null");
            return (Criteria) this;
        }

        public Criteria andOwnerIdcardEqualTo(String value) {
            addCriterion("owner_idcard =", value, "ownerIdcard");
            return (Criteria) this;
        }

        public Criteria andOwnerIdcardNotEqualTo(String value) {
            addCriterion("owner_idcard <>", value, "ownerIdcard");
            return (Criteria) this;
        }

        public Criteria andOwnerIdcardGreaterThan(String value) {
            addCriterion("owner_idcard >", value, "ownerIdcard");
            return (Criteria) this;
        }

        public Criteria andOwnerIdcardGreaterThanOrEqualTo(String value) {
            addCriterion("owner_idcard >=", value, "ownerIdcard");
            return (Criteria) this;
        }

        public Criteria andOwnerIdcardLessThan(String value) {
            addCriterion("owner_idcard <", value, "ownerIdcard");
            return (Criteria) this;
        }

        public Criteria andOwnerIdcardLessThanOrEqualTo(String value) {
            addCriterion("owner_idcard <=", value, "ownerIdcard");
            return (Criteria) this;
        }

        public Criteria andOwnerIdcardLike(String value) {
            addCriterion("owner_idcard like", value, "ownerIdcard");
            return (Criteria) this;
        }

        public Criteria andOwnerIdcardNotLike(String value) {
            addCriterion("owner_idcard not like", value, "ownerIdcard");
            return (Criteria) this;
        }

        public Criteria andOwnerIdcardIn(List<String> values) {
            addCriterion("owner_idcard in", values, "ownerIdcard");
            return (Criteria) this;
        }

        public Criteria andOwnerIdcardNotIn(List<String> values) {
            addCriterion("owner_idcard not in", values, "ownerIdcard");
            return (Criteria) this;
        }

        public Criteria andOwnerIdcardBetween(String value1, String value2) {
            addCriterion("owner_idcard between", value1, value2, "ownerIdcard");
            return (Criteria) this;
        }

        public Criteria andOwnerIdcardNotBetween(String value1, String value2) {
            addCriterion("owner_idcard not between", value1, value2, "ownerIdcard");
            return (Criteria) this;
        }

        public Criteria andOwnerAddressIsNull() {
            addCriterion("owner_address is null");
            return (Criteria) this;
        }

        public Criteria andOwnerAddressIsNotNull() {
            addCriterion("owner_address is not null");
            return (Criteria) this;
        }

        public Criteria andOwnerAddressEqualTo(String value) {
            addCriterion("owner_address =", value, "ownerAddress");
            return (Criteria) this;
        }

        public Criteria andOwnerAddressNotEqualTo(String value) {
            addCriterion("owner_address <>", value, "ownerAddress");
            return (Criteria) this;
        }

        public Criteria andOwnerAddressGreaterThan(String value) {
            addCriterion("owner_address >", value, "ownerAddress");
            return (Criteria) this;
        }

        public Criteria andOwnerAddressGreaterThanOrEqualTo(String value) {
            addCriterion("owner_address >=", value, "ownerAddress");
            return (Criteria) this;
        }

        public Criteria andOwnerAddressLessThan(String value) {
            addCriterion("owner_address <", value, "ownerAddress");
            return (Criteria) this;
        }

        public Criteria andOwnerAddressLessThanOrEqualTo(String value) {
            addCriterion("owner_address <=", value, "ownerAddress");
            return (Criteria) this;
        }

        public Criteria andOwnerAddressLike(String value) {
            addCriterion("owner_address like", value, "ownerAddress");
            return (Criteria) this;
        }

        public Criteria andOwnerAddressNotLike(String value) {
            addCriterion("owner_address not like", value, "ownerAddress");
            return (Criteria) this;
        }

        public Criteria andOwnerAddressIn(List<String> values) {
            addCriterion("owner_address in", values, "ownerAddress");
            return (Criteria) this;
        }

        public Criteria andOwnerAddressNotIn(List<String> values) {
            addCriterion("owner_address not in", values, "ownerAddress");
            return (Criteria) this;
        }

        public Criteria andOwnerAddressBetween(String value1, String value2) {
            addCriterion("owner_address between", value1, value2, "ownerAddress");
            return (Criteria) this;
        }

        public Criteria andOwnerAddressNotBetween(String value1, String value2) {
            addCriterion("owner_address not between", value1, value2, "ownerAddress");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("state is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("state is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(Integer value) {
            addCriterion("state =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(Integer value) {
            addCriterion("state <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(Integer value) {
            addCriterion("state >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("state >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(Integer value) {
            addCriterion("state <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(Integer value) {
            addCriterion("state <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<Integer> values) {
            addCriterion("state in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<Integer> values) {
            addCriterion("state not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(Integer value1, Integer value2) {
            addCriterion("state between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(Integer value1, Integer value2) {
            addCriterion("state not between", value1, value2, "state");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}